package com.car.spdier.service.dao.entity;

public class SqlTable {
	public static String INSERT_TDOWN_LOG = " INSERT INTO car.t_down_log "
			+ " ( down_dt, user_id, punishment_city_code) "
			+ " VALUES ( ?,?,?)";
	public static String INSERT_TPUNISHMENT = " INSERT INTO car.t_punishment "
			+ " ( result_dt, org_code, rs_code, rs_space, org_name, content, clause, accord, Punishment, PunishmentOther) "
			+ " VALUES (?,?,?,?,?,?,?,?,?,?)";
	public static String INSERT_TUSER_BASE_QUERY = " INSERT INTO car.t_user_base_query "
			+ " ( car_no, car_no_city, engine_code, driving_no) "
			+ " VALUES (?,?,?,?)";
	public static String INSERT_TUSER_PUNISHMENT = " INSERT INTO car.t_user_punishment_relation "
			+ " (user_id, Punishment_id, down_dt, crate_dt) "
			+ " VALUES (?,?,?, ?) ";
	public static String QUERY_TUSER_BASE=" SELECT user_id, car_no, car_no_city, engine_code, driving_no "+
	"FROM car.t_user_base_query ";

   public static String QUERY_TPUISHMENT_RSCODE="SELECT COUNT(punishment_id) FROM car.t_punishment t WHERE t.rs_code = ? ";
}
